ACCT

The ACCT dimension table contains records for each account in the GL of your organization. This includes accounts that can be found on the balance sheet, income statement, hours, and statistics.

Refer to the Axiom EPM Dimensions Setup files (AcctCoding sheet) for codes to use in \Axiom\Reports Library\System Files\Documents\Admin\Management Reporting\KHA EPM Dimensions Coding.xls.

NOTE: Some dimension tables are shared across multiple Axiom products. As a result, some of the columns listed in the following table may not display in the Dimension Maintenance Utility, depending on the Axiom products in which your organization is licensed.

The following table lists all of the options available in this dimension table:

Column Description
ACCT The Axiom Software account number. This can be the combination of the prime account and sub account, if that is how your GL system is set up.
Description The account description from the GL. Do not enter a description in all capital letters. To remove the all-caps format in the spreadsheet, use the Proper formula =Proper().
Credit

Used during the interface process to reverse the signs so values are stored in a positive condition in the database. Select one of the following valid entries:

  • dr
  • C
  • NA

Normally, Revenue and Liabilities are C, and all others are dr.

RptMap Used to group accounts. Valid entries include any account numbers in the ACCT column. The system automatically copies the information in the ACCT column to this column during installation.
Statement

Used to identify the Financial Statement category. Select one of the following valid entries:

  • BS (Balance Sheet)
  • CM
  • HoursJC (Jobcode Hours)
  • Hours
  • IS (Income Statement)
  • KeyStat
  • NI (New Initiatives)
  • Statistic
  • VCC (Variance Comments Collection)

NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA.

Type

Used to identify the major Financial Statement category. Select one of the following valid entries:

  • Allocation
  • Asset
  • Bmark (Benchmark)
  • Capital
  • Comments
  • Deduction
  • Equity
  • Expense
  • GenStat
  • HoursJC (Job Code Hours)
  • Hours
  • KeyStat
  • Liability
  • NA
  • NetAsset
  • Plan
  • Revenue
  • Scenario
  • Statistic
  • Target (Hours codes that are not reported as FTEs should be coded as Statistic.)
  • VCC (Variance Comments Collection)

NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA.

FSSummary

Used to identify summary-level Financial Statement categories. For the naming convention, use the first letter of the type category with an underscore and then the category name. For example, R_PatientRev or E_Salaries.

NOTE: This is an Axiom standard column and categories cannot be added or edited. Default value is NA.

FSDetail

Used to identify line-item Financial Statement categories. For the naming convention, use the first letter of the type category with an underscore and then the category name. For example, R_IPRev, R_OPRev. For a list of the available options, see Options for Acct.FSDetail.

NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA.

FSPayor

A variation of FSDetail used if GL accounts have payor categories; used for Budgeting Deductions models. If this is not used, match to FSDetail. Categories can be added or edited. The default value is a blank.

FPCode Used to identify the name of the Financial Planning category to use for summarization during the integration process with Axiom Financial Planning. If Axiom Financial Planning is not used, the default is NA.
FSProvider

Used to identify line-item Financial Statement categories. For the naming convention, use the first letter of the type category with an underscore and then the category name. For example, R_IPRev, R_OPRev.

NOTE: This is only used if licensed for the Provider Budget Module. The default value is NA.

FPCategory Used to identify the name of the Financial Planning category to use for transferring the financial plan targets during the integration process with Axiom Financial Planning. If Axiom Financial Planning is not used, the default is NA.
BPCode Used to identify the payors from the Budget Deductions report. During installation, the system automatically copies the information from the FPCode column to this column.
FlexStat Identifies the primary statistic used for Flexible Budgeting. The most common set up is KeyTot for all stat, hours, and expenses. Revenue uses KeyIP for IP, KeyOP for OP, and KeyOth for other patient revenue. The default is NA.
COSTCAT Identifies the account category for Axiom Cost Accounting.
FlexPercent Identifies default variable percentage (0-100%) to use for Flexible Budgeting. Values should be entered as decimals, 0.75 = 75%. The default value is 0 (zero).
CostMethod Cost Method Indicator for Offset Accounts. [ANYTHING ELSE?]
FlexGroup Used to group accounts together for Flexible Budgeting. For example, Medical Supplies or Other Expenses. The default is NA.
CostVarPct The Percent Variable for Axiom Cost Accounting; 0 = Fixed, which is used in the costing processes to determine the dollar weighted variability for calculation results.
KHAInt

Used to identify which tab an account should be interfaced to during the budget plan file create process. Valid entries include the following:

  • Stat_Rev – Select to assign to all statistics, revenue, and deduction accounts that will be budgeted in the budget plan files.

  • Expense – Select to assign to all expense and hours accounts that will be budgeted in the budget plan files.

  • NA – Select to exclude an account from all budget plan files.

KHAStdLine Used to identify default budget methodology used in budget plan files during budget plan file creation. Refer to calc methods for Stat_Rev sheet and Expense sheet in the Axiom Budgeting and Performance Reporting Administrator's Guide (Budget Plan Files chapter) for valid entries and definitions. The default value is NA.
CostDSSSummary Same as FSSummary but allows Costing and DSS to categorize their columns a bit differently and not impact Financial Reporting.
KHABgtCode Used for combining accounts together during budget plan file creation. If there are historical values for two accounts that you want to budget as one combined account, list the surviving account number on both lines. If not combining accounts, this value should match value in the Account column. The default value is 0 (zero).
CostProvider Used by the Axiom Cost Accounting system when performing the Provider RVU costing method. This identifies the cost information at the account level that is associated to the Provider, which is then allocated to his or her patients’ cost item or chargeable activities.
BudgetType

Used to identify which category an account should be interfaced to during the budget plan file interface process.

If KHAInt = Stat_Rev, valid entries are:

  • IPRev

  • OPRev

  • OthPtRev

  • OtherRev

  • Allowance

  • BadDebt

  • KeyIP

  • KeyOP

  • KeyOth

  • OthStat

If KHAInt = Expense, valid entries are:

  • Salaries
  • Benefits
  • Supplies
  • OtherExp
  • PaidHours

The default value is NA.

DropDown Identifies Drop Down pick list when adding new accounts on Stat_Rev or Expense sheets in the budget plan file. It should be the same as value in BudgetType column.
CDMStdLine

Used to identify default budget methodology for CDM budget plan files (departments which have CDMStdLine in KHACMDimGrp column of DEPT Dimension) during budget plan file creation. It is used similarly to KHAStdLine in Budget Planning workbooks.

Valid entries are:

  • Statistical accounts = CDMStatistic
  • IP Revenue accounts = CDMIPRevenue
  • OP Revenue accounts = CDMOPRevenue

Copy the remaining account assignments from KHAStdLine column.

KHASum

Used to summarize information from the Stat_Rev and Expense sheets to the Summary sheet within the budget plan files.

NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA.

CYPMethod

Used to identify the methodology used for projecting the remainder of the current fiscal year. Valid entries are dependent upon values in KHAStdLine column:

  • Input Monthly, Detail, or any of the Fixed Options:

    • Rolling12 – Use historical values from previous year's same months

    • Annual – Annualize YTD value

    • RemBud – Use remaining budget

    • CapBud – Use Total Budget less YTD actual

    • PctBud – Use percentage of CY Actual over Budget

  • Variable – Use Variable

  • Labor – Use Labor

  • FICA – Use FICA

  • Hours – Use Hours

  • GlobalExpense – Use GlobalExpense

  • Depreciation – Use Depreciation

  • IP_Per_Unit – Use IP_Per_Unit

  • OP_Per_Unit – Use OP_Per-Unit

  • Oth_Per_Unit – Use Oth_Per_Unit

PhyStdLine

Used to identify default budget methodology used in the Provider budget plan files (departments which have PhyStdLine in KHACMDimGrp column of the DEPT dimension table) during budget plan file creation. Refer to Provider Version Only: Calc Methods - Stat_Rev Sheet and Expense Sheet in the Axiom Budgeting and Performance Reporting Administrator's Guide (Budget Plan Files chapter) for valid entries and definitions. The default value is NA.

CYFMethod

Used to identify the methodology used for projecting the remainder of the current fiscal year in the current year forecast utility. This utility is available in Axiom Budgeting and Performance Reporting in the Bud Admin task pane in Financial Reporting > Financial Utilities > Current Year Forecast.

Statistics:

  • Key Dept Statistics – See Forecast Methods below, normally use Trend
  • Other Dept Statistics – See Forecast Methods below

Revenue:

  • IP Revenue – IP_Per_Unit
  • OP Revenue – OP_Per_Unit
  • Other Patient Revenue – Oth_Per_Unit
  • Other Operating Revenue – See Forecast Methods below

Salaries:

  • Hours – See Forecast Methods below
  • Salaries – Labor

All Other Accounts: See Forecast Methods below

Forecast Methods:

  • IP_Per_Unit: YTD IP_Per_Unit * Forecasted Volume
  • OP_Per_Unit: YTD OP_Per_Unit * Forecasted Volume
  • Oth_Per_unit: YTD Oth_Per_Unit * Forecasted Volume
  • Labor: Actual Hourly Rate * Forecast Hours * Budget Rate Change
  • RemBud: Remaining Budget from CYB
  • Annual: YTD / Calendar Days * Remainng Calendar Days
  • Rolling12: YTD Actual / YTD Budget * Remainder of LYA
  • PctBud: YTD Actual / YTD Budget * Remainder of CYB
  • Variable: Actual Rate per Unit * Forecast Volume
  • Trend
  • CapBud: Remaining Budget not to exceed the annual budget

You can also add additional CYFMethod columns. Create a new CYFMethod column and use this in conjunction with the CYFDimGrp column in the DEPT dimension if you need to use a different CYP method for different departments.

ReclassType A grouping attribute that is useful in defining the type of reclass to use in the in Axiom Cost Accounting reclass functionality.
AllocType Defines the type of account for indirect allocations in Axiom Cost Accounting.
BudStat

Identifies Budget Statistic accounts used in Budget Statistics Driver. Standard entries are:

  • Admits
  • PatientDays
  • Discharges
  • AdjDischarges
  • Encounters
  • ERVisits
  • ClinicVisits

You can also create custom stats to use in the Budget Statistics Driver and identify accounts appropriately. The default value is a blank.

CostAdjustmentID Used in Costing to tie Allocation and Reclass StepIDs to ACCT numbers.
CMStdLine Used to identify the StdLine for Axiom Cost Management.
KHAStandardClass KHA standard classification used for reporting.
BPCategory Used to identify the Budget Planning category.
NewDeptStdLine Used to set or update the calc method for each department.
InitStdLine

Use to make accounts available for initiatives in the Axiom Budgeting budget workbook.

In the Choose Value dialog for the InitStdLine, there are five validated values to select from. The following table lists the Initiative Standard Lines that we recommend you assign to each account type:

  • Statistics accounts to use Detail Line
  • Patient Revenue accounts to use Patient Revenue
  • Other Revenue accounts to use Detail Line
  • Deduction accounts to use Detail Line
  • Labor accounts to use Detail Line
  • Benefit accounts to use Detail Benefits w Percent
  • All other expense accounts to use Detail Line
  • Hours accounts to use Hours Line
  • For accounts not configured, NA will be the default value
RFCode Identifies the RFCode for account. Only used with Axiom Rolling Forecast. The default value is Z_Exclude.
CM_Group Used to summarize account types at a higher level for Axiom Cost Management analysis and reporting needs.
InitType

Used by the system to select the sections so that when the user refreshes the plan file, the accounts will insert into the appropriate section of the Initiative block in the Axiom Budgeting budget workbook.

In the Choose Value dialog for the InitType, you can configure up to seventeen possible values. The section types available are noted in the following list. NA is the default value until configured or for any account not configured.

  • Benefits
  • ContractLabor
  • Deduction
  • Depreciation
  • Drugs
  • Hours
  • Interest
  • IPRev
  • NA
  • OPRev
  • OtherExp
  • OtherRev
  • ProFees
  • PurchSvcs
  • Salaries
  • Statistic
  • Supplies
CM_NonLabor

Used to classify non-labor accounts in Axiom Cost Management according to FSDetail. Valid entries include the following:

  • Drugs
  • KeyStats
  • No
  • OtherExp
  • PurchSvcs
  • Supplies

These classifications are used in reporting and plan creation.

CM_Map Used to map accounts together in Axiom Cost Management. You can use this column to map closed accounts with another existing account or to group like accounts.
CM_TargetBgt Used to create team workbooks in Axiom Cost Management at the account level.